package cn.gson.springboot.model.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import com.alibaba.fastjson.JSONArray;

@Mapper
public interface BedMappers {

     //查询没有人的床位号
	 public JSONArray  selectBedAll();
	 
	 //病房和床位联合查询
	 public JSONArray selectBedSickRoomAll();
	 
	 //住院和床位表联合查询
	 public JSONArray selectChangeBedByhospid(@Param("hospid") String hospid);
	 
	 //查询调整床位的记录
	 public JSONArray selectChangeBedAllBybedid(@Param("hospid") String hospid);
	 
	 //查询病房是否安排满床位
	 public JSONArray selectBedRoomFull();
	 
	//查询病房的名称
	public JSONArray selectRoomAll(@Param("sid") Integer sid);//用于新增床位，根据科室查询病房
	public JSONArray selectRoomBedAll(@Param("sid") Integer sid);
	
	//查询病房号里的床位号
	public JSONArray selectRoomBedByid(@Param("roomid") Integer roomid);
	
	//修改病房的状态
	public void updateRoomState(@Param("roomid") Integer roomid);
}
